PUT  house_price
{
  "mappings": {
    "properties": {
      "@version": {
        "type": "keyword"
      },
      "postcode": {
        "type": "keyword"
      },
      "SAON": {
        "type": "keyword"
      },
      "OldOrNew": {
        "type": "keyword"
      },
      "price": {
        "type": "double"
      },
      "RecordStatus": {
        "type": "keyword"
      },
      "PropertyType": {
        "type": "keyword"
      },
      "TownOrCity": {
        "type": "keyword"
      },
      "Locality": {
        "type": "keyword"
      },
      "host" :{
        "type": "keyword"
      },
      "path" :{
        "type": "keyword"
      },
      "TransferDate": {
        "type":   "date",
        "format": "yyyy-MM-dd HH:mm"
      },
      "@timestamp": {
        "type":   "date"
      },
      "Transaction unique identifier": {
        "type": "keyword"
      },
      "Street": {
        "type": "keyword"
      },
      "County": {
        "type": "keyword"
      },
      "District": {
        "type": "keyword"
      },
      "ppdCategory": {
        "type": "keyword"
      },
      "PAON": {
        "type": "keyword"
      },
      "geoip": {
        "dynamic": "true",
        "properties": {
          "ip": {
            "type": "ip"
          },
          "latitude": {
            "type": "half_float"
          },
          "location": {
            "type": "geo_point"
          },
          "longitude": {
            "type": "half_float"
          }
        }
      },
      "message": {
        "type": "text",
        "norms": false
      }
    }
  },
  "settings": {
    "index": {
      "number_of_shards": "1",
      "auto_expand_replicas": "0-1",
      "number_of_replicas": "1"
    }
  }
}